create procedure [dbo].[BAEEventSetupAddLabel] @eventCode varchar(255),
     @start varchar(255),
     @registrant varchar(255),
     @functions varchar(255),
     @guest varchar(255),
     @question varchar(255),
     @summary varchar(255),
     @questionPageMessage varchar(255) as
SELECT * FROM EventSetupLabel
    WHERE EventCode = @eventCode;
    IF(@@RowCount > 0)
        BEGIN
            UPDATE EventSetupLabel
            SET StartRegistrationLabel = @start, RegistrantLabel = @registrant, FunctionsLabel = @functions, GuestLabel = @guest, QuestionLabel = @question,
            SummaryLabel = @summary, QuestionPageMessage = @questionPageMessage
            WHERE EventCode = @eventCode;
        END
    ELSE
        BEGIN
            INSERT INTO EventSetupLabel(EventCode, StartRegistrationLabel, RegistrantLabel, FunctionsLabel, GuestLabel, QuestionLabel, SummaryLabel, QuestionPageMessage)
            VALUES(@eventCode, @start, @registrant, @functions, @guest, @question,  @summary, @questionPageMessage)
        END

GO